/*
 Navicat Premium Data Transfer

 Source Server         : ali-mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.107.92.215:3306
 Source Schema         : mall-sys

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/11/2021 15:29:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_address
-- ----------------------------
DROP TABLE IF EXISTS `tb_address`;
CREATE TABLE `tb_address` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `provinceid` varchar(20) DEFAULT NULL COMMENT '省',
  `cityid` varchar(20) DEFAULT NULL COMMENT '市',
  `areaid` varchar(20) DEFAULT NULL COMMENT '县/区',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话',
  `address` varchar(200) DEFAULT NULL COMMENT '详细地址',
  `contact` varchar(50) DEFAULT NULL COMMENT '联系人',
  `is_default` varchar(1) DEFAULT NULL COMMENT '是否是默认 1默认 0否',
  `alias` varchar(50) DEFAULT NULL COMMENT '别名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of tb_address
-- ----------------------------
BEGIN;
INSERT INTO `tb_address` VALUES (59, 'zhaolei', NULL, NULL, NULL, '13900112222', '深圳中粮', '李嘉诚', '0', NULL);
INSERT INTO `tb_address` VALUES (60, 'zhaolei', NULL, NULL, NULL, '13700221122', '深圳庭威', '李佳红', '0', NULL);
INSERT INTO `tb_address` VALUES (61, 'zhaolei', NULL, NULL, NULL, '13301212233', '中腾大厦', '李佳星', '1', NULL);
INSERT INTO `tb_address` VALUES (62, 'zhangsan', NULL, NULL, NULL, '13670081376', '深圳市龙华区民治天虹', '赵三', '1', NULL);
INSERT INTO `tb_address` VALUES (63, 'zhangsan', NULL, NULL, NULL, '13670081377', '深圳市宝安区中粮商务公园', '李小龙', '0', '家里');
INSERT INTO `tb_address` VALUES (64, 'zhangsan', NULL, NULL, NULL, '13670081378', '深圳市横岭区190号', '叶问', '1', '师爷家');
INSERT INTO `tb_address` VALUES (65, 'zhangsan', NULL, NULL, NULL, '13670081379', '深圳市南山区111号', '张三', '1', '北京家');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
